package com.ruoyi.system.Fdongbei.mapper;

import com.ruoyi.system.Fdongbei.domain.ZmmWb01I;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author fufeng
 * @since 2024-12-16
 */
public interface ZmmWb01IMapper  {
    @Select(" select \n" +
            "top(1)\n" +
            "LGOBE2,\n" +
            "MAKTX,\n" +
            "LGORT,\n" +
            "LGOBE1,\n" +
            "MATNR,\n" +
            "BAOZH,\n" +
            "(select sum(cast(ERFMG as float)) from ZMM_WB_01_I where mblnr = #{mblnr} ) as ERFMG \n" +
            "from ZMM_WB_01_I \n" +
            "where mblnr =  #{mblnr}  ")
    public ZmmWb01I selectZmmWb01IbyMBLNR(@Param("mblnr") String mblnr);
}
